import excel using "figure4.xlsx", sheet("Sheet1") cellrange(a1:d7) first clear
encode year, gen(yearn)
for var fenrol menrol fshare: replace X= X*100 // convert to percent scale

twoway bar fshare yearn, c(l) barw(0.3) || ///
	scatter fenrol menrol yearn, c(l l) xlabel(, val) msym(c d) ylab(0(5)35) ///
	plotregion(style(none)) graphregion(fcolor("255  255  255")) lcolor(orange*0.65) msym(c d) col(orange*0.65) ///
	yti("Percent (%)") legend(label(1 "female share of total enrolment") label(2 "female enrolment rate") label(3 "male enrolment rate") order(2 3 1)) 
	
	

	
	